Foreign Key References Check
Short Description
Checks incoming values against in place values to ensure referential integrity
Detailed Description​
Checks incoming values against in place values to ensure referential integrity. This operator is used when there are a very high number of references to check (253). Whilst this limit sounds odd, 253 was the pre-2019 limit on foreign key references. The limit has now been raised to 10,000 and this new operator is triggered for this purpose.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.